﻿CREATE TABLE [dbo].[Kontakt] (
    [KontaktKey]         INT            IDENTITY (1, 1) NOT NULL,
    [KontaktTS]          NVARCHAR (18)  COLLATE Latin1_General_CI_AS NULL,
    [Änderung]           NVARCHAR (50)  COLLATE Latin1_General_CI_AS NULL,
    [PersKey]            INT            NULL,
    [PersKeyB]           INT            NULL,
    [TerminDatum]        DATETIME       NULL,
    [TerminZeit]         DATETIME       NULL,
    [TerminOrt]          NVARCHAR (50)  COLLATE Latin1_General_CI_AS NULL,
    [KontaktArtKey]      INT            NULL,
    [KontaktInhaltKey]   INT            NULL,
    [KontaktErgebnisKey] INT            NULL,
    [Notiz]              NTEXT          COLLATE Latin1_General_CI_AS NULL,
    [Status]             SMALLINT       DEFAULT ((0)) NULL,
    [WordDatei]          NVARCHAR (255) COLLATE Latin1_General_CI_AS NULL,
    [WordPfad]           NVARCHAR (255) COLLATE Latin1_General_CI_AS NULL,
    [ExcelDatei]         NVARCHAR (255) COLLATE Latin1_General_CI_AS NULL,
    [ExcelPfad]          NVARCHAR (255) COLLATE Latin1_General_CI_AS NULL,
    CONSTRAINT [PK_Kontakt] PRIMARY KEY CLUSTERED ([KontaktKey] ASC)
);

